Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) Character String Functions
4) Collections
5) Conversion Functions
6) Cursor
7) Date Timestamp Functions
8) Function Procedure Packages
9) Index
10) Insert Update Delete
11) Introduction
12) Large Objects
13) Linear Regression Functions
14) Miscellaneous Functions
15) Numerical Math Functions
16) Object Oriented
17) PL SQL Data Types
18) PL SQL Operators
19) PL SQL Programming
20) PL SQL Statements
21) Query Select
22) Regular Expressions Functions
23) Sequences
24) Set
25) SQL Data Types
26) SQL PLUS Session Environment
27) Statistical Functions
28) System Packages
29) System Tables Data Dictionary
30) Table
31) Table Joins
32) Transaction
33) Trigger
34) User Privilege
35) View
36) XML

Insert Update Delete
1) Adding Multiple Rows to a Table
2) Adding Rows Using the INSERT Statement
3) Change department name to lower case
4) Change more than one column value in update statement
5) Change multiple rows and multiple columns in the same UPDATE statement
6) Combine three tables with insert into statement
7) Conditional INSERT Statement
8) Copying Rows from One Table to Another (INSERT INTO select )
9) Delete all rows from a table
10) Delete and subquery
11) Delete one row
12) Delete with where clause
13) Deleting Row Data
14) If the WHERE clause were omitted, all the rows would be updated
15) Including Single and Double Quotes in a Column Value
16) Insert bulk by insert into select
17) Insert default value
18) Insert double quote
19) Insert into select
20) Insert into select with where clause
21) Insert value for specific columns
22) Modifying Rows Using the UPDATE Statement
23) Omitting the Column List
24) Removing Rows Using the DELETE Statement
25) Set clause with math expression
26) Set value based on a select statement
27) Specifying a Null Value for a Column
28) Subquery in update statement
29) The DELETE Statements
30) The RETURNING Clause
31) To delete the records of emps whose salary is below the average salary in the department (correlated subquery)
32) To insert records into a table using a subquery
33) To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery)
34) To_date() and insert statement
35) Truncate sysdate in insert statement
36) Two quotes really means one quote
37) Update a subquery
38) Update data from existing column
39) Update four columns
40) Update one row
41) Update salary based on average salary
42) Update the emp table, converting emp names to uppercase
43) Update with subquery
44) Use a q as the leading character after the parentheses
45) Use function in set clause
46) Use quote in insert statement
47) Use TO_DATE(December 31, 2005, 11
48) Use trunc in insert statement
49) Writing a DELETE Statement Containing a Subquery
50) Writing an UPDATE Statement Containing a Subquery